{#**
 * 2007-2020 PrestaShop SA and Contributors
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to https://www.prestashop.com for more information.
 *
 * @author    PrestaShop SA <contact@prestashop.com>
 * @copyright 2007-2020 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 *#}

{% extends '@PrestaShop/Admin/layout.html.twig' %}
{% trans_default_domain "Admin.Advparameters.Feature" %}

{% block content %}
    {% block sql_manager_info_block %}
        <div class="row">
            <div class="col">
                <div class="alert alert-info" role="alert">
                    <p class="alert-text">{{ 'How do I create a new SQL query?'|trans({}, 'Admin.Advparameters.Help') }}</p>
                    <ul>
                        <li>{{ 'Click "Add New".'|trans({}, 'Admin.Advparameters.Help') }}</li>
                        <li>{{ 'Fill in the fields and click "Save".'|trans({}, 'Admin.Advparameters.Help') }}</li>
                        <li>{{ 'You can then view the query results by clicking on the Edit action in the dropdown menu'|trans({}, 'Admin.Advparameters.Help') }}</li>
                        <li>{{ 'You can also export the query results as a CSV file by clicking on the Export button'|trans({}, 'Admin.Advparameters.Help') }}</li>
                    </ul>
                </div>
            </div>
        </div>
    {% endblock %}

    {% block sql_manager_warning_block %}
        <div class="row">
            <div class="col">
                <div class="alert alert-warning" role="alert">
                    <p class="alert-text">{{ 'When saving the query, only the "SELECT" SQL statement is allowed.'|trans({}, 'Admin.Advparameters.Notification') }}</p>
                </div>
            </div>
        </div>
    {% endblock %}

    {% block sql_manager_list_panel %}
        <div class="row">
            <div class="col">
                {% include '@PrestaShop/Admin/Common/Grid/grid_panel.html.twig' with {'grid': requestSqlGrid} %}
            </div>
        </div>
    {% endblock %}

    {% block sql_manager_settings_panel %}
        <div class="row justify-content-center">
            <div class="col">
                {% include '@PrestaShop/Admin/Configure/AdvancedParameters/RequestSql/Blocks/settings_panel.html.twig' %}
            </div>
        </div>
    {% endblock %}
{% endblock %}

{% block javascripts %}
    {{ parent() }}

    <script src="{{ asset('themes/new-theme/public/sql_manager.bundle.js') }}"></script>
    <script src="{{ asset('themes/default/js/bundle/pagination.js') }}"></script>
{% endblock %}
